home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Amiga Plus 2002 #11
/
Amiga Plus CD - 2002 - No. 11.iso
/
amigaoscd
/
amigapluscd
/
AP-Website
/
links
/
admin
/
sites_main.php
< prev
next >
Wrap
PHP Script
|
2001-07-22
|
5KB
|
223 lines
<?
// *******************************************************************
// admin/sites_main.php
// *******************************************************************
include("../include/config.php");
include("../include/functions.php");
include("../include/common.php");
$language = $gl["Language"];
include("../include/lang/$language.php");
include("../include/session.php");
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title></title>
<link rel = "stylesheet" type = "text/css" href = "style.css" />
</head>
<?=$adm_body?>
<?
if(isset($submit)){
$total_sql = "
select
$tb_links.ID as link_id,
$tb_links.SiteURL as site_url,
$tb_links.SiteName as site_name,
$tb_categories.Category as cat_name
from
$tb_links
left join
$tb_categories
on
$tb_categories.ID=$tb_links.Category
where
$tb_links.Category='$Category'
";
if($Category == "0"){
$total_sql = "
select
$tb_links.ID as link_id,
$tb_links.SiteURL as site_url,
$tb_links.SiteName as site_name,
$tb_categories.Category as cat_name
from
$tb_links
left join
$tb_categories
on
$tb_categories.ID=$tb_links.Category
where
$tb_links.Category='0'
or
$tb_links.Category=''
";
}
if($Category == "-1"){
$total_sql = "
select
$tb_temp.ID as link_id,
$tb_temp.SiteURL as site_url,
$tb_temp.SiteName as site_name,
'' as cat_name
from
$tb_temp
";
}
$total_result = sql_query($total_sql);
$total_sites = sql_num_rows($total_result);
$pp=30;
$np=4;
if(!isset($cp)){
$cp=0;
}
if(!isset($sr)){
$sr=0;
}
$nav_url = "sites_main.php?Category=" . $Category . "&submit=1i&";
?><table cellspacing="0" cellpadding="5" border="1" align="center" width="100%"><?
echo "<tr><td class=\"theader\" colspan=\"";
if($Category > 0){
echo "5";
} else {
echo "4";
}
echo "\">". nav_links($total_sites, $pp, $np, $cp, $nav_url) . "</td></tr>";
echo "<tr bgcolor=\"#EEEEEE\"><td class=\"theader\">Site Name</td>";
if($Category > "0"){
echo "<td class=\"theader\">Category</td>";
}
echo "<td class=\"theader\">";
if($Category == "-1"){
echo "Validate";
} else {
echo "Edit";
}
echo "</td><td class=\"theader\">Reviews</td><td class=\"theader\">Delete</td></tr>";
$sql = "
select
$tb_links.ID as link_id,
$tb_links.SiteURL as site_url,
$tb_links.SiteName as site_name,
$tb_categories.Category as cat_name
from
$tb_links
left join
$tb_categories
on
$tb_categories.ID=$tb_links.Category
where
$tb_links.Category='$Category'
limit
$sr, $pp
";
if($Category == "0"){
$sql = "
select
$tb_links.ID as link_id,
$tb_links.SiteURL as site_url,
$tb_links.SiteName as site_name,
$tb_categories.Category as cat_name
from
$tb_links
left join
$tb_categories
on
$tb_categories.ID=$tb_links.Category
where
$tb_links.Category='0'
or
$tb_links.Category=''
limit
$sr, $pp
";
}
if($Category == "-1"){
$sql = "
select
$tb_temp.ID as link_id,
$tb_temp.SiteURL as site_url,
$tb_temp.SiteName as site_name,
'' as cat_name
from
$tb_temp
limit
$sr, $pp
";
}
$result = sql_query($sql);
while($rows = sql_fetch_array($result)){
echo "<tr><td><a href=\"" . $rows[site_url] . "\" target=\"_blank\">";
echo stripslashes($rows[site_name]) . "</a></td>";
if($Category > "0"){
echo "<td class=\"text\">" . eregi_replace("_", " ", $rows[cat_name]) . "</td>";
}
echo "<td>";
if($Category == "-1"){
echo "<a href=\"validate.php?" . session_name() . "=" . session_id();
echo "&ID=" . $rows[link_id];
echo "\">Validate</a>";
} else {
echo "<a href=\"edit_site.php?" . session_name() . "=" . session_id();
echo "&ID=" . $rows[link_id];
echo "\">Edit</a>";
}
echo "</td><td><a href=\"reviews.php?" . session_name() . "=";
echo session_id() . "&SiteID=" . $rows[link_id];
echo "\">Reviews</a></td><td><a href=\"delete_site.php?";
echo session_name() . "=" . session_id() . "&dbtable=";
if($Category >= "0"){
echo "links";
} else {
echo "temp";
}
echo "&ID=" . $rows[link_id] . "\">Delete</a></td></tr>";
}
echo "</table>";
}
?>
</body>
</html>